SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[usp_SearchSurveyByTopic]

	(
	@param_topic NVARCHAR(100)

	)

AS
	/* SET NOCOUNT ON */
	SELECT * FROM dbo.JOL_SurveyManagement_Theme WHERE topic LIKE '%'+@param_topic+'%' ORDER BY update_time,add_time DESC
	RETURN
GO
